﻿--alter table PublicOfficialInfo
--add Office varchar(200) null,
--YM datetime null
--- 2012.10.19日





--USE [XuHuiCommunityDB]
--GO

--/****** Object:  Table [dbo].[ExameOrg]    Script Date: 10/19/2012 16:12:39 ******/
--IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ExameOrg]') AND type in (N'U'))
--DROP TABLE [dbo].[ExameOrg]
--GO

--USE [XuHuiCommunityDB]
--GO

--/****** Object:  Table [dbo].[ExameOrg]    Script Date: 10/19/2012 16:12:39 ******/
--SET ANSI_NULLS ON
--GO

--SET QUOTED_IDENTIFIER ON
--GO

--CREATE TABLE [dbo].[ExameOrg](
--	[ID] [int] IDENTITY(1,1) NOT NULL,
--	[ExameID] [int] NOT NULL,
--	[OrgForHRID] [int] NOT NULL,
-- CONSTRAINT [PK_ExameOrg] PRIMARY KEY CLUSTERED 
--(
--	[ID] ASC
--)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
--) ON [PRIMARY]

--GO
---xufeng  2012.10.19 



--ALTER TABLE dbo.Emp_BasicInfoRegister
--ADD DutyAttribute VARCHAR(20);

--- xufeng 2012.11.9






--ALTER TABLE dbo.Emp_BasicInfo ADD 
--EmpStatus VARCHAR(50);
--go

--UPDATE dbo.Emp_BasicInfo SET
--EmpStatus = '在职'
